package com.situ.water_read.mapper;

import com.situ.water_read.pojo.RdYearmonth;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author Angel
 * @since 2020-12-01
 */
@Mapper
public interface RdYearmonthMapper extends BaseMapper<RdYearmonth> {

    RdYearmonth queryyear(RdYearmonth yearmonth);
    @Select("select * from rd_yearmonth r inner join sy_emp s on r.InitEmpID=s.id order by r.ReadYear,r.ReadMonth desc")
    List<Map> selectall();
}
